V@  vaWhen the in stock number is equal to or below this amount, the product must be reordered.7 699999696orditems.dbfOrder detail itemsJ5Number of units of this product are on order.7 69999999999D''@ʬ@TM_('.customercust_id cust_id,employeeemp_id emp_id.ordersorder_id order_id4productsproduct_id product_id7e΅G9QxqP2ΆβP\i|dH .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) +D$LPSD$H |F +&-#discontinu ML CustomActio-&-#cust_id_a MC(6) 111" 22 n,&-#company MC(40)ical install,&-#contact MC(30)ustomDlg 33 *&- #title MC(30)rs with minimu,&-#address MC(60)dll, 113" 2)&- #city MC(15)alled to run fr+&-#region MC(15) 25 Cust1&-#postalcode_a MC(10)schdpl3,&-#country MC(15)es 27 yes S*&- #phone MC(24)ion Shared Op(&- #fax MC(24)eSharedMode 30 4&-#maxordamtMY NOCPTRANSAppl.&-#order_id_a MC(6)nge Micros-&-#cust_id_b MC(6)aging messa*&-#emp_id MC(6)yes 32 yes Sc,&-#to_name MC(40) Time and In/&-#to_address MC(60)92 vita,&-#to_city MC(15)r for sendin.&-#to_region MC(15)ionDlg 37 1&-#postalcode_b MC(10)e's Sch/&-#to_country MC(15)ols. Opti/&-#ship_count MC(15)change G,&-#ship_via MC(6)yes %25 3+&-#order_date MDgram Group 454&-#order_amtMY NOCPTRANSes c-&-#order_dsc MN(3)ms. OptionD4&-#order_netMY NOCPTRANSows +&-#require_by MD%h\Proof 40 +&-#shipped_on MDoup 371 n2&-#freightMY NOCPTRANSrogram+&-#line_no MN(5)vices These s.&-#order_id_b MC(6)of systems0&-#product_id_a MC(6)g Allows7&-#unit_price_aMY NOCPTRANS4/&-#quantityMN(12,3) 371 0&-#product_id_b MC(6) 46 Mic.&-#prod_name MC(40)ion MSMAIL-&-#eng_name MC(40) StampCDInf/&-#no_in_unit MC(20)53 51 7&-#unit_price_bMY NOCPTRANSL4&-#unit_costMY NOCPTRANSt"""/&-#in_stockMN(12,3)Files /&-#on_orderMN(12,3)etConfigI1&-#reorder_atMN(12,3)? 58 5>&-!#testdata!customer.country MC(15)q.0$(,P<&-#testdata!customer.title MC(30)40)6XI"n-@_2+CkڄIVzLbں!SAն*.W9r>&-!#testdata!customer.contact MC(30)#&-MY NOCPTRANSI $iNը >&-!#testdata!customer.company MC(40)3&-##testdata!products.prod_name=&-!#testdata!customer.cust_id MC(6) Orditems.quantity) FROM testdata!products INNER JOIN test9.0$(,PQR / %d '+testdata!customer*SELECT Customer.cust_id, Customer.company, Customer.contact, Customer.title, Customer.country FROM testdata!customer WHERE Customer.country = ?whichcountry) v.0$(,PGcustomer.dbfcust_idCustomer informationccUnique Customer ID code made up of the first five character of the Customer's Company name.**Primary contact for this Customer.SSRegion of the country the Customer lives in; For the US, this is the State.DDPostalcode of the Customer; For the US, this is the Zipcode. 7$6999999.99Femployee.dbfemp_idEmployee information Employees.##Unique numeric Employee ID.SSRegion of the country the Employee lives in; For the US, this is the state.DDPostalcode of the Employee; For the US, this is the Zipcode.::Employee ID of the direct report of this Employee.;;Embedded bitmap of a current photo of the Employee.Aorders.dbforder_idCustomer orders!!Unique ID for this Order. Order.ZZCustomer ID of the Customer of this Order; Links this table to the Customer table.TTEmployee ID of the Employee who made this sale; Links to the Employee table.aaSpecifies the Ship To name when shipping an order, if different from purchasing Customer.L$ƒ;֋L$nnSpecifies the Ship To address when shipping an order, if different from purchasing Customer's address.hhSpecifies the Ship To city when shipping an order, if different from purchasing Customer's city.Specifies the Ship To region when shipping an order, if different from purchasing Customer's region. In the US, this is the state.Specifies the Ship To postalcode when shipping an order, if different from purchasing Customer's postalcode. In the US, this is the Zipcode.nnSpecifies the Ship To country when shipping an order, if different from purchasing Customer's country.IISpecifies the ship method when sending the order to the customer.J0Amount Product is sold to Customers for.6999999.99 7$##Unique ID for this Product.BBSpecifies the date the Customer must receive the order by.44Specifies the date the order was shipped on.4(Quantity of the product ordered. 69999P6Total amount of the order before the discount.6999999.99 7$E2Discount percentage given to the Customer.7 699%9%G-Total of the order less the discount.6999999.99 7$C)Total cost of shipping the order.6999999.99 7$33Order ID number; Links to the Orders table.GGProduct ID of the product ordered; Links to the Products table.T:Unit price of the product at the time of the sale.6999999.99 7$Wproducts.dbfproduct_id)Product and Inventory information==Specifies whether this Product has been discontinued.DDDescription of number of items in each unit of this Product.T:Amount Product is purchased for sale to Customers.6999999.99 7$I;Number of units of this product currently in stock.6999999..0 .0$(.0$(0.0$(,8.0$(,P@.0$(,PQH.0$(,PQRS.0$(,PQR /^.0$(,PQR / %di.0$(,PQR / %d '.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!products&.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id..0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id)9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) &&-3&-##testdata!customer.cust_id_a?&-##testdata!customer.cust_id_a MC(6)&&-1&-!#testdata!customer.company>&-!#testdata!customer.company MC(40)&&-1&-!#testdata!customer.contact>&-!#testdata!customer.contact MC(30)&&-/&-#testdata!customer.title<&-#testdata!customer.title MC(30)&&-1&-!#testdata!customer.address>&-!#testdata!customer.address MC(60)&&-.&-#testdata!customer.city;&-#testdata!customer.city MC(15)&&-0&- #testdata!customer.region=&- #testdata!customer.region MC(15)&&-6&-&#testdata!customer.postalcode_aC&-&#testdata!customer.postalcode_a MC(10)&&-1&-!#testdata!customer.country>&-!#testdata!customer.country MC(15)&&-/&-#testdata!customer.phone<&-#testdata!customer.phone MC(24)&&--&-#testdata!customer.fax:&-#testdata!customer.fax MC(24)&&-3&-##testdata!customer.maxordamt<&-##testdata!customer.maxordamt MY&&-2&-"#testdata!orders.order_id_a>&-"#testdata!orders.order_id_a MC(6)&&-1&-!#testdata!orders.cust_id_b=&-!#testdata!orders.cust_id_b MC(6)&&-.&-#testdata!orders.emp_id:&-#testdata!orders.emp_id MC(6)&&-/&-#testdata!orders.to_name<&-#testdata!orders.to_name MC(40)&&-2&-"#testdata!orders.to_address?&-"#testdata!orders.to_address MC(60)&&-/&-#testdata!orders.to_city<&-#testdata!orders.to_city MC(15)&&-1&-!#testdata!orders.to_region>&-!#testdata!orders.to_region MC(15)&&-4&-$#testdata!orders.postalcode_bA&-$#testdata!orders.postalcode_b MC(10)&&-2&-"#testdata!orders.to_country?&-"#testdata!orders.to_country MC(15)&&-2&-"#testdata!orders.ship_count?&-"#testdata!orders.ship_count MC(15)&&-0&- #testdata!orders.ship_via<&- #testdata!orders.ship_via MC(6)&&-2&-"#testdata!orders.order_date;&-"#testdata!orders.order_date MD&&-1&-!#testdata!orders.order_amt:&-!#testdata!orders.order_amt MY&&-1&-!#testdata!orders.order_dsc=&-!#testdata!orders.order_dsc MN(3)&&-1&-!#testdata!orders.order_net:&-!#testdata!orders.order_net MY&&-2&-"#testdata!orders.require_by;&-"#testdata!orders.require_by MD&&-2&-"#testdata!orders.shipped_on;&-"#testdata!orders.shipped_on MD&&-/&-#testdata!orders.freight8&-#testdata!orders.freight MY&&-1&-!#testdata!orditems.line_no=&-!#testdata!orditems.line_no MN(5)&&-4&-$#testdata!orditems.order_id_b@&-$#testdata!orditems.order_id_b MC(6)&&-6&-&#testdata!orditems.product_id_aB&-&#testdata!orditems.product_id_a MC(6)&&-6&-&#testdata!orditems.unit_price_a?&-&#testdata!orditems.unit_price_a MY&&-2&-"#testdata!orditems.quantityA&-"#testdata!orditems.quantityMN(12,3)&&-6&-&#testdata!products.product_id_bB&-&#testdata!products.product_id_b MC(6)&&-3&-##testdata!products.prod_name@&-##testdata!products.prod_name MC(40)&&-2&-"#testdata!products.eng_name?&-"#testdata!products.eng_name MC(40)&&-4&-$#testdata!products.no_in_unitA&-$#testdata!products.no_in_unit MC(20)&&-6&-&#testdata!products.unit_price_b?&-&#testdata!products.unit_price_b MY&&-3&-##testdata!products.unit_cost<&-##testdata!products.unit_cost MY&&-2&-"#testdata!products.in_stockA&-"#testdata!products.in_stockMN(12,3)&&-2&-"#testdata!products.on_orderA&-"#testdata!products.on_orderMN(12,3)&&-4&-$#testdata!products.reorder_atC&-$#testdata!products.reorder_atMN(12,3)&&-4&-$#testdata!products.discontinu=&-$#testdata!products.discontinu ML9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) 9.0$(,PQR / %d 'M+testdata!customer,testdata!orders,testdata!orditems,testdata!productsp*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) ?&-##testdata!customer.cust_id_a MC(6)-&-#cust_id_a MC(6)-&-#cust_id_a MC(6)-&-#cust_id_a MC(6)>&-!#testdata!customer.company MC(40),&-#company MC(40),&-#company MC(40),&-#company MC(40)>&-!#testdata!customer.contact MC(30),&-#contact MC(30),&-#contact MC(30),&-#contact MC(30)<&-#testdata!customer.title MC(30)*&- #title MC(30)*&- #title MC(30)*&- #title MC(30)>&-!#testdata!customer.address MC(60),&-#address MC(60),&-#address MC(60),&-#address MC(60);&-#testdata!customer.city MC(15))&- #city MC(15))&- #city MC(15))&- #city MC(15)=&- #testdata!customer.region MC(15)+&-#region MC(15)+&-#region MC(15)+&-#region MC(15)C&-&#testdata!customer.postalcode_a MC(10)1&-#postalcode_a MC(10)1&-#postalcode_a MC(10)1&-#postalcode_a MC(10)>&-!#testdata!customer.country MC(15),&-#country MC(15),&-#country MC(15),&-#country MC(15)<&-#testdata!customer.phone MC(24)*&- #phone MC(24)*&- #phone MC(24)*&- #phone MC(24):&-#testdata!customer.fax MC(24)(&- #fax MC(24)(&- #fax MC(24)(&- #fax MC(24)F&-##testdata!customer.maxordamtMY NOCPTRANS4&-#maxordamtMY NOCPTRANS4&-#maxordamtMY NOCPTRANS4&-#maxordamtMY NOCPTRANS>&-"#testdata!orders.order_id_a MC(6).&-#order_id_a MC(6).&-#order_id_a MC(6).&-#order_id_a MC(6)=&-!#testdata!orders.cust_id_b MC(6)-&-#cust_id_b MC(6)-&-#cust_id_b MC(6)-&-#cust_id_b MC(6):&-#testdata!orders.emp_id MC(6)*&-#emp_id MC(6)*&-#emp_id MC(6)*&-#emp_id MC(6)<&-#testdata!orders.to_name MC(40),&-#to_name MC(40),&-#to_name MC(40),&-#to_name MC(40)?&-"#testdata!orders.to_address MC(60)/&-#to_address MC(60)/&-#to_address MC(60)/&-#to_address MC(60)<&-#testdata!orders.to_city MC(15),&-#to_city MC(15),&-#to_city MC(15),&-#to_city MC(15)>&-!#testdata!orders.to_region MC(15).&-#to_region MC(15).&-#to_region MC(15).&-#to_region MC(15)A&-$#testdata!orders.postalcode_b MC(10)1&-#postalcode_b MC(10)1&-#postalcode_b MC(10)1&-#postalcode_b MC(10)?&-"#testdata!orders.to_country MC(15)/&-#to_country MC(15)/&-#to_country MC(15)/&-#to_country MC(15)?&-"#testdata!orders.ship_count MC(15)/&-#ship_count MC(15)/&-#ship_count MC(15)/&-#ship_count MC(15)<&- #testdata!orders.ship_via MC(6),&-#ship_via MC(6),&-#ship_via MC(6),&-#ship_via MC(6);&-"#testdata!orders.order_date MD+&-#order_date MD+&-#order_date MD+&-#order_date MDD&-!#testdata!orders.order_amtMY NOCPTRANS4&-#order_amtMY NOCPTRANS4&-#order_amtMY NOCPTRANS4&-#order_amtMY NOCPTRANS=&-!#testdata!orders.order_dsc MN(3)-&-#order_dsc MN(3)-&-#order_dsc MN(3)-&-#order_dsc MN(3)D&-!#testdata!orders.order_netMY NOCPTRANS4&-#order_netMY NOCPTRANS4&-#order_netMY NOCPTRANS4&-#order_netMY NOCPTRANS;&-"#testdata!orders.require_by MD+&-#require_by MD+&-#require_by MD+&-#require_by MD;&-"#testdata!orders.shipped_on MD+&-#shipped_on MD+&-#shipped_on MD+&-#shipped_on MDB&-#testdata!orders.freightMY NOCPTRANS2&-#freightMY NOCPTRANS2&-#freightMY NOCPTRANS2&-#freightMY NOCPTRANS=&-!#testdata!orditems.line_no MN(5)+&-#line_no MN(5)+&-#line_no MN(5)+&-#line_no MN(5)@&-$#testdata!orditems.order_id_b MC(6).&-#order_id_b MC(6).&-#order_id_b MC(6).&-#order_id_b MC(6)B&-&#testdata!orditems.product_id_a MC(6)0&-#product_id_a MC(6)0&-#product_id_a MC(6)0&-#product_id_a MC(6)I&-&#testdata!orditems.unit_price_aMY NOCPTRANS7&-#unit_price_aMY NOCPTRANS7&-#unit_price_aMY NOCPTRANS7&-#unit_price_aMY NOCPTRANSA&-"#testdata!orditems.quantityMN(12,3)/&-#quantityMN(12,3)/&-#quantityMN(12,3)/&-#quantityMN(12,3)B&-&#testdata!products.product_id_b MC(6)0&-#product_id_b MC(6)0&-#product_id_b MC(6)0&-#product_id_b MC(6)@&-##testdata!products.prod_name MC(40).&-#prod_name MC(40).&-#prod_name MC(40).&-#prod_name MC(40)?&-"#testdata!products.eng_name MC(40)-&-#eng_name MC(40)-&-#eng_name MC(40)-&-#eng_name MC(40)A&-$#testdata!products.no_in_unit MC(20)/&-#no_in_unit MC(20)/&-#no_in_unit MC(20)/&-#no_in_unit MC(20)I&-&#testdata!products.unit_price_bMY NOCPTRANS7&-#unit_price_bMY NOCPTRANS7&-#unit_price_bMY NOCPTRANS7&-#unit_price_bMY NOCPTRANSF&-##testdata!products.unit_costMY NOCPTRANS4&-#unit_costMY NOCPTRANS4&-#unit_costMY NOCPTRANS4&-#unit_costMY NOCPTRANSA&-"#testdata!products.in_stockMN(12,3)/&-#in_stockMN(12,3)/&-#in_stockMN(12,3)/&-#in_stockMN(12,3)A&-"#testdata!products.on_orderMN(12,3)/&-#on_orderMN(12,3)/&-#on_orderMN(12,3)/&-#on_orderMN(12,3)C&-$#testdata!products.reorder_atMN(12,3)1&-#reorder_atMN(12,3)1&-#reorder_atMN(12,3)1&-#reorder_atMN(12,3)=&-$#testdata!products.discontinu ML+&-#discontinu ML+&-#discontinu ML+&-#discontinu ML .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) + .0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) +Q.0$(,PQR / %d '*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ?dStart_Date AND Orders.order_date <= ?dEnd_Date GROUP BY Orders.order_id ORDER BY Orders.order_id) M+testdata!customer,testdata!orders,testdata!orditems,testdata!products9.0$(,PQR / %d 'p*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) M+testdata!customer,testdata!orders,testdata!orditems,testdata!products9.0$(,PQR / %d 'p*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) M+testdata!customer,testdata!orders,testdata!orditems,testdata!products9.0$(,PQR / %d 'p*SELECT * FROM testdata!customer INNER JOIN testdata!orders INNER JOIN testdata!orditems INNER JOIN testdata!products ON Orditems.product_id = Products.product_id ON Orders.order_id = Orditems.order_id ON Customer.cust_id = Orders.cust_id WHERE Orders.order_date >= ( ?dStart_Date ) AND Orders.order_date <= ( ?dEnd_Date ) ORDER BY Orders.order_id) M+testdata!customer,testdata!orders,testdata!orditems,testdata!products&&-!&-#cust_id_a-&-#cust_id_a MC(6)&&-&-#company,&-#company MC(40)&&-&-#contact,&-#contact MC(30)&&-&- #title*&- #title MC(30)&&-&-#address,&-#address MC(60)&&-&- #city)&- #city MC(15)&&-&-#region+&-#region MC(15)&&-$&-#postalcode_a1&-#postalcode_a MC(10)&&-&-#country,&-#country MC(15)&&-&- #phone*&- #phone MC(24)&&-&- #fax(&- #fax MC(24)&&-!&-#maxordamt*&-#maxordamt MY&&-"&-#order_id_a.&-#order_id_a MC(6)&&-!&-#cust_id_b-&-#cust_id_b MC(6)&&-&-#emp_id*&-#emp_id MC(6)&&-&-#to_name,&-#to_name MC(40)&&-"&-#to_address/&-#to_address MC(60)&&-&-#to_city,&-#to_city MC(15)&&-!&-#to_region.&-#to_region MC(15)&&-$&-#postalcode_b1&-#postalcode_b MC(10)&&-"&-#to_country/&-#to_country MC(15)&&-"&-#ship_count/&-#ship_count MC(15)&&- &-#ship_via,&-#ship_via MC(6)&&-"&-#order_date+&-#order_date MD&&-!&-#order_amt*&-#order_amt MY&&-!&-#order_dsc-&-#order_dsc MN(3)&&-!&-#order_net*&-#order_net MY&&-"&-#require_by+&-#require_by MD&&-"&-#shipped_on+&-#shipped_on MD&&-&-#freight(&-#freight MY&&-&-#line_no+&-#line_no MN(5)&&-"&-#order_id_b.&-#order_id_b MC(6)&&-$&-#product_id_a0&-#product_id_a MC(6)&&-$&-#unit_price_a-&-#unit_price_a MY&&- &-#quantity/&-#quantityMN(12,3)&&-$&-#product_id_b0&-#product_id_b MC(6)&&-!&-#prod_name.&-#prod_name MC(40)&&- &-#eng_name-&-#eng_name MC(40)&&-"&-#no_in_unit/&-#no_in_unit MC(20)&&-$&-#unit_price_b-&-#unit_price_b MY&&-!&-#unit_cost*&-#unit_cost MY&&- &-#in_stock/&-#in_stockMN(12,3)&&- &-#on_order/&-#on_orderMN(12,3)&&-"&-#reorder_at1&-#reorder_atMN(12,3)&&-"&-#discontinu+&-#discontinu ML